﻿CREATE TABLE [dbo].[Orders] (
    [Ono]  INT NOT NULL,
    [Cno]  INT NULL,
    [Gno]  INT NULL,
    [Gnum] INT NULL,
    PRIMARY KEY CLUSTERED ([Ono] ASC),
    FOREIGN KEY ([Gno]) REFERENCES [dbo].[Goods] ([Gno]) ON DELETE CASCADE,
    FOREIGN KEY ([Cno]) REFERENCES [dbo].[Client] ([Cno]) ON DELETE CASCADE
);

